Table B–2: Query limitations
|
–
|
Limits
|
|
Characters in a query name
|
1-48.
|
|
Fields in a query
|
1-64.
|
|
Query definitions in a single query directory (qd7) file
|
1-256.
|
|
Query source files (que#####.p) in a single operating system directory
|
1-99,999.
|
|
QD7 files in a single operating system directory
|
1-390.
|
|
Sort fields per table
|
1-16.
|
|
Characters in the selection criteria (WHERE clause) of a table
|
Based on Stash Area (-stsh) parameter value (1-31, default 2) or Stack Size (-s) parameter value (3-63, default 63).
|
|
Stored custom table relationships (WHERE relationships)
|
Available disk space.
|
|
Stored natural table relationships
|
Available disk space.
|
|
Table WHERE clauses
|
Available disk space.
|